package com.asohofrucol.dao;


import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;


import com.asohofrucol.model.TechnicalAssistanceVisit;

public interface TechnicalAssistanceVisitDao extends
BasicSaveDao<TechnicalAssistanceVisit, Long>{
	@Query("SELECT p FROM TechnicalAssistanceVisit p WHERE p.technicalAssistance.id = :technicalAssistanceId order by p.visitDate" )
	public List<TechnicalAssistanceVisit> listByTechnicalAssistance(
			@Param("technicalAssistanceId") Long technicalAssistanceId);
}
